﻿CREATE PROCEDURE [acms].[Site_GetByRootUrl]
	@RootUrl varchar(50)
AS
	SELECT *
	FROM Site_View
	Where RootUrl = @RootUrl
	
RETURN 0;